
create procedure TVPOrderInsert
(
	@CustCode varchar(5), 
	@OrdNo integer output, 
	@OrdDate datetime output)
as 
	set @OrdDate = GETDATE();
	insert into TVPOrd (OrdDate, CustCode) 
		values (@OrdDate, @CustCode); 
	select @OrdNo = SCOPE_IDENTITY()

create procedure TVPItemInsert
(
	@OrdNo integer, 
	@ProdCode integer, 
	@Qty integer)
as 
	insert into TVPItem (OrdNo, ProdCode, Qty) 
		values (@OrdNo, @ProdCode, @Qty)
		
		
		
		
		
		
		
		
create type TVPParam as table(ProdCode integer, Qty integer)

create procedure TVPOrderEntry
(
	@CustCode varchar(5), 
	@Items TVPParam READONLY, 
	@OrdNo integer output, 
	@OrdDate datetime output)
as 
	set @OrdDate = GETDATE();
	insert into TVPOrd (OrdDate, CustCode) 
		values (@OrdDate, @CustCode); 
	select @OrdNo = SCOPE_IDENTITY(); 
	insert into TVPItem (OrdNo, ProdCode, Qty) 
		select @OrdNo, ProdCode, Qty from @Items
				
				